-
This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. Read more
-
This article describes how to import into DAX Studio the performance metrics that can be exported by the Power BI Performance Analyzer, simplifying the analysis of slower queries in a report. Read more
-
This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains condition in the filter pane or the filter mode of the Smart Filter Pro… Read more
-
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
-
This article describes how to optimize a slow Power BI report with a large number of card visuals, by obtaining the same graphical layout with a smaller number of visuals. Read more
-
This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation. Read more
-
The second edition of the Optimizing DAX video course is available: new content, a new book, and some on the behind-the-scenes of the project. Read more
-
Power BI introduced dynamic format strings in May 2023. In this article, we briefly introduce this functionality and then dive into a few technical details of its implementation. Read more
-
This article explains the roles of the formula engine and of the storage engine used to execute DAX queries. Read more
-
SQLBI+ is our new subscription service for advanced content that supports professional model authors who create semantic models for Power BI and Analysis Services. Read more